CREATE TABLE [dbo].[u_lote]
(
[Id] [int] NOT NULL,
[lote] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[idjurisdiccion] [int] NOT NULL,
[idregion] [int] NULL,
[idSupervisor] [numeric] (10, 0) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[u_lote] ADD CONSTRAINT [PK_u_lote] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[u_lote] WITH NOCHECK ADD CONSTRAINT [FK_u_lote_u_jurisdiccion] FOREIGN KEY ([idjurisdiccion]) REFERENCES [dbo].[u_jurisdiccion] ([idJurisdiccion]) NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[u_lote] NOCHECK CONSTRAINT [FK_u_lote_u_jurisdiccion]
GO
